﻿CREATE PROCEDURE [dbo].[proc_ProT_ClassT2]
(
	@id INT,
	@F_ID INT
)
AS
BEGIN
IF(@id=0)
BEGIN
	SELECT * FROM [ProT_ClassT2] WHERE [F_ID]=@F_ID
END
ELSE IF (@F_ID=0)
	BEGIN
		SELECT ClassName FROM [ProT_ClassT2] WHERE [id]=@id
	END
ELSE
	BEGIN
		SELECT * FROM ProT_ClassT2 
	END
	
	SET NOCOUNT ON;


END
